﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="OrmSmackdown" targetNamespace="http://tempuri.org/OrmSmackdown.xsd" xmlns:mstns="http://tempuri.org/OrmSmackdown.xsd" xmlns="http://tempuri.org/OrmSmackdown.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ORM_SmackdownConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ORM_SmackdownConnectionString1 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.OrmSmackdown.Properties.Settings.GlobalReference.Default.ORM_SmackdownConnectionString1" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PeopleTableAdapter" GeneratorDataComponentClassName="PeopleTableAdapter" Name="People" UserDataComponentName="PeopleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ORM_SmackdownConnectionString1 (Settings)" DbObjectName="ORM_Smackdown.dbo.People" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[People] WHERE (([PersonId] = @Original_PersonId) AND ([FirstName] = @Original_FirstName) AND ([LastName] = @Original_LastName) AND ([Email] = @Original_Email) AND ((@IsNull_CompanyId = 1 AND [CompanyId] IS NULL) OR ([CompanyId] = @Original_CompanyId)) AND ([RoleId] = @Original_RoleId) AND ((@IsNull_ManagerPersonId = 1 AND [ManagerPersonId] IS NULL) OR ([ManagerPersonId] = @Original_ManagerPersonId)) AND ([UserType] = @Original_UserType))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PersonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_FirstName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_LastName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CompanyId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CompanyId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CompanyId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CompanyId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RoleId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ManagerPersonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ManagerPersonId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ManagerPersonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ManagerPersonId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UserType" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UserType" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[People] ([FirstName], [LastName], [Email], [CompanyId], [RoleId], [ManagerPersonId], [UserType]) VALUES (@FirstName, @LastName, @Email, @CompanyId, @RoleId, @ManagerPersonId, @UserType);
SELECT PersonId, FirstName, LastName, Email, CompanyId, RoleId, ManagerPersonId, UserType FROM People WHERE (PersonId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CompanyId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CompanyId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RoleId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ManagerPersonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ManagerPersonId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UserType" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UserType" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PersonId, FirstName, LastName, Email, CompanyId, RoleId, ManagerPersonId, UserType FROM dbo.People</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[People] SET [FirstName] = @FirstName, [LastName] = @LastName, [Email] = @Email, [CompanyId] = @CompanyId, [RoleId] = @RoleId, [ManagerPersonId] = @ManagerPersonId, [UserType] = @UserType WHERE (([PersonId] = @Original_PersonId) AND ([FirstName] = @Original_FirstName) AND ([LastName] = @Original_LastName) AND ([Email] = @Original_Email) AND ((@IsNull_CompanyId = 1 AND [CompanyId] IS NULL) OR ([CompanyId] = @Original_CompanyId)) AND ([RoleId] = @Original_RoleId) AND ((@IsNull_ManagerPersonId = 1 AND [ManagerPersonId] IS NULL) OR ([ManagerPersonId] = @Original_ManagerPersonId)) AND ([UserType] = @Original_UserType));
SELECT PersonId, FirstName, LastName, Email, CompanyId, RoleId, ManagerPersonId, UserType FROM People WHERE (PersonId = @PersonId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CompanyId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CompanyId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RoleId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ManagerPersonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ManagerPersonId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UserType" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UserType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PersonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_FirstName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_LastName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CompanyId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CompanyId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CompanyId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CompanyId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RoleId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ManagerPersonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ManagerPersonId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ManagerPersonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ManagerPersonId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_UserType" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="UserType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PersonId" ColumnName="PersonId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PersonId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PersonId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PersonId" DataSetColumn="PersonId" />
              <Mapping SourceColumn="FirstName" DataSetColumn="FirstName" />
              <Mapping SourceColumn="LastName" DataSetColumn="LastName" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="CompanyId" DataSetColumn="CompanyId" />
              <Mapping SourceColumn="RoleId" DataSetColumn="RoleId" />
              <Mapping SourceColumn="ManagerPersonId" DataSetColumn="ManagerPersonId" />
              <Mapping SourceColumn="UserType" DataSetColumn="UserType" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PortalPeopleXrefTableAdapter" GeneratorDataComponentClassName="PortalPeopleXrefTableAdapter" Name="PortalPeopleXref" UserDataComponentName="PortalPeopleXrefTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ORM_SmackdownConnectionString1 (Settings)" DbObjectName="ORM_Smackdown.dbo.PortalPeopleXref" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[PortalPeopleXref] WHERE (([PortalId] = @Original_PortalId) AND ([PersonId] = @Original_PersonId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PortalId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PortalId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PersonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[PortalPeopleXref] ([PortalId], [PersonId]) VALUES (@PortalId, @PersonId);
SELECT PortalId, PersonId FROM PortalPeopleXref WHERE (PersonId = @PersonId) AND (PortalId = @PortalId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PortalId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PortalId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PersonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PortalId, PersonId FROM dbo.PortalPeopleXref</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[PortalPeopleXref] SET [PortalId] = @PortalId, [PersonId] = @PersonId WHERE (([PortalId] = @Original_PortalId) AND ([PersonId] = @Original_PersonId));
SELECT PortalId, PersonId FROM PortalPeopleXref WHERE (PersonId = @PersonId) AND (PortalId = @PortalId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PortalId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PortalId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PersonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PortalId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PortalId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PersonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PortalId" DataSetColumn="PortalId" />
              <Mapping SourceColumn="PersonId" DataSetColumn="PersonId" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PortalsTableAdapter" GeneratorDataComponentClassName="PortalsTableAdapter" Name="Portals" UserDataComponentName="PortalsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ORM_SmackdownConnectionString1 (Settings)" DbObjectName="ORM_Smackdown.dbo.Portals" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Portals] WHERE (([PortalId] = @Original_PortalId) AND ([PortalName] = @Original_PortalName) AND ([AdminUserId] = @Original_AdminUserId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PortalId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PortalId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PortalName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PortalName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AdminUserId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AdminUserId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Portals] ([PortalName], [AdminUserId]) VALUES (@PortalName, @AdminUserId);
SELECT PortalId, PortalName, AdminUserId FROM Portals WHERE (PortalId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PortalName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PortalName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdminUserId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AdminUserId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PortalId, PortalName, AdminUserId FROM dbo.Portals</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Portals] SET [PortalName] = @PortalName, [AdminUserId] = @AdminUserId WHERE (([PortalId] = @Original_PortalId) AND ([PortalName] = @Original_PortalName) AND ([AdminUserId] = @Original_AdminUserId));
SELECT PortalId, PortalName, AdminUserId FROM Portals WHERE (PortalId = @PortalId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PortalName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PortalName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdminUserId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AdminUserId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PortalId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PortalId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PortalName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PortalName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AdminUserId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AdminUserId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PortalId" ColumnName="PortalId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PortalId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PortalId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PortalId" DataSetColumn="PortalId" />
              <Mapping SourceColumn="PortalName" DataSetColumn="PortalName" />
              <Mapping SourceColumn="AdminUserId" DataSetColumn="AdminUserId" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AddressesTableAdapter" GeneratorDataComponentClassName="AddressesTableAdapter" Name="Addresses" UserDataComponentName="AddressesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ORM_SmackdownConnectionString1 (Settings)" DbObjectName="ORM_Smackdown.dbo.Addresses" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Addresses] WHERE (([AddressId] = @Original_AddressId) AND ([PersonId] = @Original_PersonId) AND ([IsDefault] = @Original_IsDefault) AND ([Line1] = @Original_Line1) AND ((@IsNull_Line2 = 1 AND [Line2] IS NULL) OR ([Line2] = @Original_Line2)) AND ([City] = @Original_City) AND ([State] = @Original_State) AND ([ZipCode] = @Original_ZipCode) AND ([ZipCodePlusFour] = @Original_ZipCodePlusFour))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AddressId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AddressId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PersonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsDefault" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsDefault" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Line1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Line1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Line2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Line2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Line2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Line2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_State" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ZipCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ZipCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ZipCodePlusFour" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ZipCodePlusFour" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Addresses] ([PersonId], [IsDefault], [Line1], [Line2], [City], [State], [ZipCode], [ZipCodePlusFour]) VALUES (@PersonId, @IsDefault, @Line1, @Line2, @City, @State, @ZipCode, @ZipCodePlusFour);
SELECT AddressId, PersonId, IsDefault, Line1, Line2, City, State, ZipCode, ZipCodePlusFour FROM Addresses WHERE (AddressId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PersonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsDefault" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsDefault" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Line1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Line1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Line2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Line2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@State" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ZipCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ZipCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ZipCodePlusFour" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ZipCodePlusFour" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT AddressId, PersonId, IsDefault, Line1, Line2, City, State, ZipCode, ZipCodePlusFour FROM dbo.Addresses</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Addresses] SET [PersonId] = @PersonId, [IsDefault] = @IsDefault, [Line1] = @Line1, [Line2] = @Line2, [City] = @City, [State] = @State, [ZipCode] = @ZipCode, [ZipCodePlusFour] = @ZipCodePlusFour WHERE (([AddressId] = @Original_AddressId) AND ([PersonId] = @Original_PersonId) AND ([IsDefault] = @Original_IsDefault) AND ([Line1] = @Original_Line1) AND ((@IsNull_Line2 = 1 AND [Line2] IS NULL) OR ([Line2] = @Original_Line2)) AND ([City] = @Original_City) AND ([State] = @Original_State) AND ([ZipCode] = @Original_ZipCode) AND ([ZipCodePlusFour] = @Original_ZipCodePlusFour));
SELECT AddressId, PersonId, IsDefault, Line1, Line2, City, State, ZipCode, ZipCodePlusFour FROM Addresses WHERE (AddressId = @AddressId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PersonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsDefault" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsDefault" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Line1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Line1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Line2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Line2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@State" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ZipCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ZipCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ZipCodePlusFour" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ZipCodePlusFour" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AddressId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AddressId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PersonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsDefault" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsDefault" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Line1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Line1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Line2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Line2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Line2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Line2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_State" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ZipCode" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ZipCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ZipCodePlusFour" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ZipCodePlusFour" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="AddressId" ColumnName="AddressId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AddressId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AddressId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="AddressId" DataSetColumn="AddressId" />
              <Mapping SourceColumn="PersonId" DataSetColumn="PersonId" />
              <Mapping SourceColumn="IsDefault" DataSetColumn="IsDefault" />
              <Mapping SourceColumn="Line1" DataSetColumn="Line1" />
              <Mapping SourceColumn="Line2" DataSetColumn="Line2" />
              <Mapping SourceColumn="City" DataSetColumn="City" />
              <Mapping SourceColumn="State" DataSetColumn="State" />
              <Mapping SourceColumn="ZipCode" DataSetColumn="ZipCode" />
              <Mapping SourceColumn="ZipCodePlusFour" DataSetColumn="ZipCodePlusFour" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RolesTableAdapter" GeneratorDataComponentClassName="RolesTableAdapter" Name="Roles" UserDataComponentName="RolesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ORM_SmackdownConnectionString1 (Settings)" DbObjectName="ORM_Smackdown.dbo.Roles" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Roles] WHERE (([RoleId] = @Original_RoleId) AND ([RoleName] = @Original_RoleName) AND ([IsForPortal] = @Original_IsForPortal) AND ([IsForContact] = @Original_IsForContact))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RoleId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_RoleName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RoleName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsForPortal" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsForPortal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsForContact" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsForContact" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Roles] ([RoleName], [IsForPortal], [IsForContact]) VALUES (@RoleName, @IsForPortal, @IsForContact);
SELECT RoleId, RoleName, IsForPortal, IsForContact FROM Roles WHERE (RoleId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@RoleName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RoleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsForPortal" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsForPortal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsForContact" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsForContact" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT RoleId, RoleName, IsForPortal, IsForContact FROM dbo.Roles</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Roles] SET [RoleName] = @RoleName, [IsForPortal] = @IsForPortal, [IsForContact] = @IsForContact WHERE (([RoleId] = @Original_RoleId) AND ([RoleName] = @Original_RoleName) AND ([IsForPortal] = @Original_IsForPortal) AND ([IsForContact] = @Original_IsForContact));
SELECT RoleId, RoleName, IsForPortal, IsForContact FROM Roles WHERE (RoleId = @RoleId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@RoleName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RoleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsForPortal" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsForPortal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsForContact" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsForContact" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RoleId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RoleId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_RoleName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RoleName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsForPortal" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsForPortal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsForContact" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsForContact" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="RoleId" ColumnName="RoleId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@RoleId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="RoleId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="RoleId" DataSetColumn="RoleId" />
              <Mapping SourceColumn="RoleName" DataSetColumn="RoleName" />
              <Mapping SourceColumn="IsForPortal" DataSetColumn="IsForPortal" />
              <Mapping SourceColumn="IsForContact" DataSetColumn="IsForContact" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="OrmSmackdown" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="OrmSmackdown" msprop:Generator_UserDSName="OrmSmackdown" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="People" msprop:Generator_UserTableName="People" msprop:Generator_RowDeletedName="PeopleRowDeleted" msprop:Generator_TableClassName="PeopleDataTable" msprop:Generator_RowChangedName="PeopleRowChanged" msprop:Generator_RowClassName="PeopleRow" msprop:Generator_RowChangingName="PeopleRowChanging" msprop:Generator_RowEvArgName="PeopleRowChangeEvent" msprop:Generator_RowEvHandlerName="PeopleRowChangeEventHandler" msprop:Generator_TablePropName="People" msprop:Generator_TableVarName="tablePeople" msprop:Generator_RowDeletingName="PeopleRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PersonId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="PersonId" msprop:Generator_ColumnPropNameInRow="PersonId" msprop:Generator_ColumnVarNameInTable="columnPersonId" msprop:Generator_ColumnPropNameInTable="PersonIdColumn" type="xs:int" />
              <xs:element name="FirstName" msprop:Generator_UserColumnName="FirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastName" msprop:Generator_UserColumnName="LastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_UserColumnName="Email" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInTable="EmailColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CompanyId" msprop:Generator_UserColumnName="CompanyId" msprop:Generator_ColumnPropNameInRow="CompanyId" msprop:Generator_ColumnVarNameInTable="columnCompanyId" msprop:Generator_ColumnPropNameInTable="CompanyIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="RoleId" msprop:Generator_UserColumnName="RoleId" msprop:Generator_ColumnPropNameInRow="RoleId" msprop:Generator_ColumnVarNameInTable="columnRoleId" msprop:Generator_ColumnPropNameInTable="RoleIdColumn" type="xs:int" />
              <xs:element name="ManagerPersonId" msprop:Generator_UserColumnName="ManagerPersonId" msprop:Generator_ColumnPropNameInRow="ManagerPersonId" msprop:Generator_ColumnVarNameInTable="columnManagerPersonId" msprop:Generator_ColumnPropNameInTable="ManagerPersonIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="UserType" msprop:Generator_UserColumnName="UserType" msprop:Generator_ColumnPropNameInRow="UserType" msprop:Generator_ColumnVarNameInTable="columnUserType" msprop:Generator_ColumnPropNameInTable="UserTypeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PortalPeopleXref" msprop:Generator_UserTableName="PortalPeopleXref" msprop:Generator_RowDeletedName="PortalPeopleXrefRowDeleted" msprop:Generator_TableClassName="PortalPeopleXrefDataTable" msprop:Generator_RowChangedName="PortalPeopleXrefRowChanged" msprop:Generator_RowClassName="PortalPeopleXrefRow" msprop:Generator_RowChangingName="PortalPeopleXrefRowChanging" msprop:Generator_RowEvArgName="PortalPeopleXrefRowChangeEvent" msprop:Generator_RowEvHandlerName="PortalPeopleXrefRowChangeEventHandler" msprop:Generator_TablePropName="PortalPeopleXref" msprop:Generator_TableVarName="tablePortalPeopleXref" msprop:Generator_RowDeletingName="PortalPeopleXrefRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PortalId" msprop:Generator_UserColumnName="PortalId" msprop:Generator_ColumnPropNameInRow="PortalId" msprop:Generator_ColumnVarNameInTable="columnPortalId" msprop:Generator_ColumnPropNameInTable="PortalIdColumn" type="xs:int" />
              <xs:element name="PersonId" msprop:Generator_UserColumnName="PersonId" msprop:Generator_ColumnPropNameInRow="PersonId" msprop:Generator_ColumnVarNameInTable="columnPersonId" msprop:Generator_ColumnPropNameInTable="PersonIdColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Portals" msprop:Generator_UserTableName="Portals" msprop:Generator_RowDeletedName="PortalsRowDeleted" msprop:Generator_TableClassName="PortalsDataTable" msprop:Generator_RowChangedName="PortalsRowChanged" msprop:Generator_RowClassName="PortalsRow" msprop:Generator_RowChangingName="PortalsRowChanging" msprop:Generator_RowEvArgName="PortalsRowChangeEvent" msprop:Generator_RowEvHandlerName="PortalsRowChangeEventHandler" msprop:Generator_TablePropName="Portals" msprop:Generator_TableVarName="tablePortals" msprop:Generator_RowDeletingName="PortalsRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PortalId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="PortalId" msprop:Generator_ColumnPropNameInRow="PortalId" msprop:Generator_ColumnVarNameInTable="columnPortalId" msprop:Generator_ColumnPropNameInTable="PortalIdColumn" type="xs:int" />
              <xs:element name="PortalName" msprop:Generator_UserColumnName="PortalName" msprop:Generator_ColumnPropNameInRow="PortalName" msprop:Generator_ColumnVarNameInTable="columnPortalName" msprop:Generator_ColumnPropNameInTable="PortalNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AdminUserId" msprop:Generator_UserColumnName="AdminUserId" msprop:Generator_ColumnPropNameInRow="AdminUserId" msprop:Generator_ColumnVarNameInTable="columnAdminUserId" msprop:Generator_ColumnPropNameInTable="AdminUserIdColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Addresses" msprop:Generator_UserTableName="Addresses" msprop:Generator_RowDeletedName="AddressesRowDeleted" msprop:Generator_TableClassName="AddressesDataTable" msprop:Generator_RowChangedName="AddressesRowChanged" msprop:Generator_RowClassName="AddressesRow" msprop:Generator_RowChangingName="AddressesRowChanging" msprop:Generator_RowEvArgName="AddressesRowChangeEvent" msprop:Generator_RowEvHandlerName="AddressesRowChangeEventHandler" msprop:Generator_TablePropName="Addresses" msprop:Generator_TableVarName="tableAddresses" msprop:Generator_RowDeletingName="AddressesRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="AddressId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="AddressId" msprop:Generator_ColumnPropNameInRow="AddressId" msprop:Generator_ColumnVarNameInTable="columnAddressId" msprop:Generator_ColumnPropNameInTable="AddressIdColumn" type="xs:int" />
              <xs:element name="PersonId" msprop:Generator_UserColumnName="PersonId" msprop:Generator_ColumnPropNameInRow="PersonId" msprop:Generator_ColumnVarNameInTable="columnPersonId" msprop:Generator_ColumnPropNameInTable="PersonIdColumn" type="xs:int" />
              <xs:element name="IsDefault" msprop:Generator_UserColumnName="IsDefault" msprop:Generator_ColumnPropNameInRow="IsDefault" msprop:Generator_ColumnVarNameInTable="columnIsDefault" msprop:Generator_ColumnPropNameInTable="IsDefaultColumn" type="xs:boolean" />
              <xs:element name="Line1" msprop:Generator_UserColumnName="Line1" msprop:Generator_ColumnPropNameInRow="Line1" msprop:Generator_ColumnVarNameInTable="columnLine1" msprop:Generator_ColumnPropNameInTable="Line1Column">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Line2" msprop:Generator_UserColumnName="Line2" msprop:Generator_ColumnPropNameInRow="Line2" msprop:Generator_ColumnVarNameInTable="columnLine2" msprop:Generator_ColumnPropNameInTable="Line2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="City" msprop:Generator_UserColumnName="City" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_ColumnVarNameInTable="columnCity" msprop:Generator_ColumnPropNameInTable="CityColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="State" msprop:Generator_UserColumnName="State" msprop:Generator_ColumnPropNameInRow="State" msprop:Generator_ColumnVarNameInTable="columnState" msprop:Generator_ColumnPropNameInTable="StateColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ZipCode" msprop:Generator_UserColumnName="ZipCode" msprop:Generator_ColumnPropNameInRow="ZipCode" msprop:Generator_ColumnVarNameInTable="columnZipCode" msprop:Generator_ColumnPropNameInTable="ZipCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ZipCodePlusFour" msprop:Generator_UserColumnName="ZipCodePlusFour" msprop:Generator_ColumnPropNameInRow="ZipCodePlusFour" msprop:Generator_ColumnVarNameInTable="columnZipCodePlusFour" msprop:Generator_ColumnPropNameInTable="ZipCodePlusFourColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Roles" msprop:Generator_UserTableName="Roles" msprop:Generator_RowDeletedName="RolesRowDeleted" msprop:Generator_TableClassName="RolesDataTable" msprop:Generator_RowChangedName="RolesRowChanged" msprop:Generator_RowClassName="RolesRow" msprop:Generator_RowChangingName="RolesRowChanging" msprop:Generator_RowEvArgName="RolesRowChangeEvent" msprop:Generator_RowEvHandlerName="RolesRowChangeEventHandler" msprop:Generator_TablePropName="Roles" msprop:Generator_TableVarName="tableRoles" msprop:Generator_RowDeletingName="RolesRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="RoleId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="RoleId" msprop:Generator_ColumnPropNameInRow="RoleId" msprop:Generator_ColumnVarNameInTable="columnRoleId" msprop:Generator_ColumnPropNameInTable="RoleIdColumn" type="xs:int" />
              <xs:element name="RoleName" msprop:Generator_UserColumnName="RoleName" msprop:Generator_ColumnPropNameInRow="RoleName" msprop:Generator_ColumnVarNameInTable="columnRoleName" msprop:Generator_ColumnPropNameInTable="RoleNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsForPortal" msprop:Generator_UserColumnName="IsForPortal" msprop:Generator_ColumnPropNameInRow="IsForPortal" msprop:Generator_ColumnVarNameInTable="columnIsForPortal" msprop:Generator_ColumnPropNameInTable="IsForPortalColumn" type="xs:boolean" />
              <xs:element name="IsForContact" msprop:Generator_UserColumnName="IsForContact" msprop:Generator_ColumnPropNameInRow="IsForContact" msprop:Generator_ColumnVarNameInTable="columnIsForContact" msprop:Generator_ColumnPropNameInTable="IsForContactColumn" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:People" />
      <xs:field xpath="mstns:PersonId" />
    </xs:unique>
    <xs:unique name="PortalPeopleXref_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PortalPeopleXref" />
      <xs:field xpath="mstns:PortalId" />
      <xs:field xpath="mstns:PersonId" />
    </xs:unique>
    <xs:unique name="Portals_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Portals" />
      <xs:field xpath="mstns:PortalId" />
    </xs:unique>
    <xs:unique name="Addresses_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Addresses" />
      <xs:field xpath="mstns:AddressId" />
    </xs:unique>
    <xs:unique name="Roles_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Roles" />
      <xs:field xpath="mstns:RoleId" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_People_Manager" msdata:parent="People" msdata:child="People" msdata:parentkey="PersonId" msdata:childkey="ManagerPersonId" msprop:Generator_UserRelationName="FK_People_Manager" msprop:Generator_RelationVarName="relationFK_People_Manager" msprop:Generator_UserChildTable="People" msprop:Generator_UserParentTable="People" msprop:Generator_ParentPropName="PeopleRowParent" msprop:Generator_ChildPropName="GetPeopleRows" />
      <msdata:Relationship name="FK_PortalPeopleXref_People" msdata:parent="People" msdata:child="PortalPeopleXref" msdata:parentkey="PersonId" msdata:childkey="PersonId" msprop:Generator_UserRelationName="FK_PortalPeopleXref_People" msprop:Generator_RelationVarName="relationFK_PortalPeopleXref_People" msprop:Generator_UserChildTable="PortalPeopleXref" msprop:Generator_UserParentTable="People" msprop:Generator_ParentPropName="PeopleRow" msprop:Generator_ChildPropName="GetPortalPeopleXrefRows" />
      <msdata:Relationship name="FK_PortalPeopleXref_Portals" msdata:parent="Portals" msdata:child="PortalPeopleXref" msdata:parentkey="PortalId" msdata:childkey="PortalId" msprop:Generator_UserRelationName="FK_PortalPeopleXref_Portals" msprop:Generator_RelationVarName="relationFK_PortalPeopleXref_Portals" msprop:Generator_UserChildTable="PortalPeopleXref" msprop:Generator_UserParentTable="Portals" msprop:Generator_ParentPropName="PortalsRow" msprop:Generator_ChildPropName="GetPortalPeopleXrefRows" />
      <msdata:Relationship name="FK_Portals_Users" msdata:parent="People" msdata:child="Portals" msdata:parentkey="PersonId" msdata:childkey="AdminUserId" msprop:Generator_UserRelationName="FK_Portals_Users" msprop:Generator_RelationVarName="relationFK_Portals_Users" msprop:Generator_UserChildTable="Portals" msprop:Generator_UserParentTable="People" msprop:Generator_ParentPropName="PeopleRow" msprop:Generator_ChildPropName="GetPortalsRows" />
      <msdata:Relationship name="FK_Addresses_People" msdata:parent="People" msdata:child="Addresses" msdata:parentkey="PersonId" msdata:childkey="PersonId" msprop:Generator_UserRelationName="FK_Addresses_People" msprop:Generator_RelationVarName="relationFK_Addresses_People" msprop:Generator_UserChildTable="Addresses" msprop:Generator_UserParentTable="People" msprop:Generator_ParentPropName="PeopleRow" msprop:Generator_ChildPropName="GetAddressesRows" />
      <msdata:Relationship name="FK_People_Roles" msdata:parent="Roles" msdata:child="People" msdata:parentkey="RoleId" msdata:childkey="RoleId" msprop:Generator_UserRelationName="FK_People_Roles" msprop:Generator_RelationVarName="relationFK_People_Roles" msprop:Generator_UserChildTable="People" msprop:Generator_UserParentTable="Roles" msprop:Generator_ParentPropName="RolesRow" msprop:Generator_ChildPropName="GetPeopleRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>